package com.atguigu.tingshu.album.service.impl;

import com.atguigu.tingshu.album.mapper.AlbumInfoMapper;
import com.atguigu.tingshu.album.mapper.TrackInfoMapper;
import com.atguigu.tingshu.album.mapper.TrackStatMapper;
import com.atguigu.tingshu.album.service.TrackInfoService;
import com.atguigu.tingshu.album.service.VodService;
import com.atguigu.tingshu.common.constant.SystemConstant;
import com.atguigu.tingshu.common.result.Result;
import com.atguigu.tingshu.model.album.AlbumInfo;
import com.atguigu.tingshu.model.album.TrackInfo;
import com.atguigu.tingshu.model.album.TrackStat;
import com.atguigu.tingshu.query.album.TrackInfoQuery;
import com.atguigu.tingshu.user.client.UserInfoFeignClient;
import com.atguigu.tingshu.vo.album.*;
import com.atguigu.tingshu.vo.user.UserInfoVo;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.BeansException;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.util.Assert;
import org.springframework.util.CollectionUtils;

import java.math.BigDecimal;
import java.util.*;
import java.util.stream.Collectors;

@Slf4j
@Service
@SuppressWarnings({"all"})
public class TrackInfoServiceImpl extends ServiceImpl<TrackInfoMapper, TrackInfo> implements TrackInfoService {

    @Autowired
    private TrackInfoMapper trackInfoMapper;

    @Autowired
    private TrackStatMapper trackStatMapper;

    @Autowired
    private AlbumInfoMapper albumInfoMapper;

    @Autowired
    private VodService vodService;

    @Autowired
    private UserInfoFeignClient userInfoFeignClient;

    @Override
    @Transactional(rollbackFor = Exception.class)
    public void saveTrackInfo(TrackInfoVo trackInfoVo, Long userId) {
        try {
            //track_info  track_stat  album_info
            //track_info
            TrackInfo trackInfo = new TrackInfo();
            //有相同属性值进行拷贝
            BeanUtils.copyProperties(trackInfoVo, trackInfo);
            //赋值用户id
            trackInfo.setUserId(userId);
            //order_num 第一种查询当前专辑对应的声音奇数+1 第二种 查询专辑包含声音总数+1
            AlbumInfo albumInfo = albumInfoMapper.selectById(trackInfo.getAlbumId());
            trackInfo.setOrderNum(albumInfo.getIncludeTrackCount() + 1);
            //处理流媒体数据 时长和数据 页面没传递; filed 查询流媒体数据，然后赋值，调用云点播的api
            TrackMediaInfoVo trackMediaInfoVo = vodService.getMediaInfo(trackInfoVo.getMediaFileId());
            //赋值
            trackInfo.setMediaUrl(trackMediaInfoVo.getMediaUrl());
            trackInfo.setMediaDuration(trackMediaInfoVo.getDuration());
            trackInfo.setMediaType(trackMediaInfoVo.getType());
            trackInfo.setMediaSize(trackMediaInfoVo.getSize());
            //保存声音结束
            trackInfoMapper.insert(trackInfo);
            //track_stat
            saveTrackStat(trackInfo.getId(), SystemConstant.TRACK_STAT_PLAY);
            saveTrackStat(trackInfo.getId(), SystemConstant.TRACK_STAT_COLLECT);
            saveTrackStat(trackInfo.getId(), SystemConstant.TRACK_STAT_PRAISE);
            saveTrackStat(trackInfo.getId(), SystemConstant.TRACK_STAT_COMMENT);
            // album_info 更新数据
            albumInfo.setIncludeTrackCount(albumInfo.getIncludeTrackCount() + 1);
            //更新操作
            albumInfoMapper.updateById(albumInfo);
        } catch (BeansException e) {
            log.error("保存声音信息失败：{}", e);
            throw new RuntimeException(e);
        }
    }

    private void saveTrackStat(Long trackId, String statPlay) {
        TrackStat trackStat = new TrackStat();
        //赋值
        trackStat.setTrackId(trackId);
        trackStat.setStatType(statPlay);
        trackStat.setStatNum(new Random().nextInt(100000));
        //数据保存
        trackStatMapper.insert(trackStat);
    }

    @Override
    public IPage<TrackListVo> findUserTrackPage(Page<TrackListVo> trackListVoPage, TrackInfoQuery trackInfoQuery) {
        return trackInfoMapper.selectUserTrackPage(trackListVoPage, trackInfoQuery);
    }

    @Override
    @Transactional(rollbackFor = Exception.class)
    public void removeTrackInfo(Long trackId) {
        TrackInfo trackInfo = this.getById(trackId);
        //track_info  track_stat  album_info
        //track_info
        trackInfoMapper.deleteById(trackId);
        //track_stat
        trackStatMapper.delete(new LambdaQueryWrapper<TrackStat>().eq(TrackStat::getTrackId, trackId));
        //album_info 更新 include_track_count
        AlbumInfo albumInfo = albumInfoMapper.selectById(trackInfo.getAlbumId());
        albumInfo.setIncludeTrackCount(albumInfo.getIncludeTrackCount() - 1);
        albumInfoMapper.updateById(albumInfo);
        //重新管理 order_num
        //update track_info set order_num = order_num - 1 where album_id = 1 and order_num > 52 and is_deleted = 0
        trackInfoMapper.updateOrderNum(trackInfo.getAlbumId(), trackInfo.getOrderNum());
        //删除云点播
        vodService.deletedMediaFile(trackInfo.getMediaFileId());

    }

    @Override
    public void updateTrackInfo(Long trackId, TrackInfoVo trackInfoVo) {
        //	trackId + trackInfoVo 知道用户具体的修改操作了！
        // track_info
        TrackInfo trackInfo = this.getById(trackId);
        String originMediaFileId = trackInfo.getMediaFileId();

        BeanUtils.copyProperties(trackInfoVo, trackInfo);

        if (!originMediaFileId.equals(trackInfoVo.getMediaFileId())) {
            TrackMediaInfoVo mediaInfo = vodService.getMediaInfo(trackInfo.getMediaFileId());
            trackInfo.setMediaDuration(mediaInfo.getDuration());
            trackInfo.setMediaType(mediaInfo.getType());
            trackInfo.setMediaSize(mediaInfo.getSize());
            trackInfo.setMediaFileId(trackInfoVo.getMediaFileId());

            vodService.deletedMediaFile(originMediaFileId);
        }

        this.updateById(trackInfo);

    }

    @Override
    public IPage<AlbumTrackListVo> findAlbumTrackPag(Page<AlbumTrackListVo> albumTrackListVoPage, Long albumId, Long userId) {
         /*
            1.  需要先根据专辑Id获取到声音列表;
            2.  判断用户是否登录：
                    null != userId;

                    null == userId;
                2.1 判断专辑类型;
                2.2 除用户已购买的声音Id；
         */
        IPage<AlbumTrackListVo> albumTrackListVoIPage = trackInfoMapper.selectAlbumTrackPag(albumTrackListVoPage, albumId);
        //  查询专辑类型:
        AlbumInfo albumInfo = albumInfoMapper.selectById(albumId);
        // 判断用户是否登录
        if (null == userId) {
            // 未登录专辑类型是付费时，除免费试听声音都要收费
            if (!SystemConstant.ALBUM_PAY_TYPE_FREE.equals(albumInfo.getPayType())) {
                //免费试听5集
                Integer tracksForFree = albumInfo.getTracksForFree();
                //除免费试听外都要收费
                albumTrackListVoIPage.getRecords().stream()
                        .filter(albumTrackListVo -> albumTrackListVo.getOrderNum() > tracksForFree)
                        .forEach(albumTrackListVo -> albumTrackListVo.setIsShowPaidMark(true));
            }
        } else {
            //登录了，远程调用获取用户信息
            Result<UserInfoVo> userInfoVoResult = userInfoFeignClient.getUserInfoVo(userId);
            Assert.notNull(userInfoVoResult, "查询用户信息失败");
            UserInfoVo userInfoVo = userInfoVoResult.getData();
            Assert.notNull(userInfoVo, "查询用户信息失败");
            //声明一个变量；记录是否需要付费；false：免费，true：付费
            boolean isPaid = false;
            //判断专辑类型：vip 免费
            if (SystemConstant.ALBUM_PAY_TYPE_VIPFREE.equals(albumInfo.getPayType())) {
                //前提是用户是vip会员且会员过期
                if ((userInfoVo.getIsVip() == 1 && userInfoVo.getVipExpireTime().before(new Date())) || userInfoVo.getIsVip() == 0) {
                    //需要付费
                    isPaid = true;
                }
            } else if (SystemConstant.ALBUM_PAY_TYPE_REQUIRE.equals(albumInfo.getPayType())) {
                //必须付费
                isPaid = true;
            }
/*            else {
                //免费
                isPaid = false;
            }*/
            //判断专辑是否付费
            if (isPaid) {
                //  远程调用，需要知道用户购买了哪些声音; 专辑Id; 付费声音列表;userId--从本地线程中获取;
                List<AlbumTrackListVo> albumTrackListVoList = albumTrackListVoIPage.getRecords().stream().filter(albumTrackListVo -> albumTrackListVo.getOrderNum() > albumInfo.getTracksForFree()).collect(Collectors.toList());
                //付费声音id
                List<Long> trackIdList = albumTrackListVoList.stream().map(AlbumTrackListVo::getTrackId).collect(Collectors.toList());
                //	获取用户购买的声音列表; 如果用户购买了； 将购买的声音Id与状态存储到map集合中; map.put(trackId,1)-买过; map.put(trackId,0)-未买过;
                Result<Map<Long, Integer>> mapResult = userInfoFeignClient.userIsPaidTrack(albumId, trackIdList);
                Assert.notNull(mapResult, "查询用户付费声音失败");
                Map<Long, Integer> map = mapResult.getData();
                //  map.put(trackId,1)-买过; map.put(trackId,0)-未买过;
                for (AlbumTrackListVo albumTrackListVo : albumTrackListVoList) {
                    albumTrackListVo.setIsShowPaidMark(map.get(albumTrackListVo.getTrackId()) == 0);
                }

            }
        }
        //返回数据
        return albumTrackListVoIPage;
    }


    @Override
    public void updateTrackStat(TrackStatMqVo trackStatMqVo) {
        //1.更新声音播放量  //update track_stat set stat_num = stat_num +1 where track_id = ? and stat_type = '0701' and is_deleted = 0
        //判断是否属于播放量
        if (SystemConstant.TRACK_STAT_PLAY.equals(trackStatMqVo.getStatType())) {
            //调用更新方法
            trackInfoMapper.updateTrackStat(trackStatMqVo.getCount(), trackStatMqVo.getTrackId(), trackStatMqVo.getStatType());
            //2.更新专辑播放量
            albumInfoMapper.updateAlbumStat(trackStatMqVo.getCount(), trackStatMqVo.getAlbumId(), SystemConstant.ALBUM_STAT_PLAY);
        } else if (SystemConstant.TRACK_STAT_COLLECT.equals(trackStatMqVo.getStatType())) {
            //暂无
        }
    }

    @Override
    public List<Map<String, Object>> findUserTrackPaidList(Long trackId, Long userId) {
              /*
        1.  从当前点击的声音开始，计算有多少需要付费的声音列表;
        2.  查询用户是否购买过当前专辑对应的声音，然后与1步骤进行过滤;
         */
        List<Map<String, Object>> list = new ArrayList<>();
        //  获取对象
        TrackInfo trackInfo = this.getById(trackId);
        //获取当前声音的排序值
        Integer orderNum = trackInfo.getOrderNum();
        //获取当前用户购买的声音列表
        Result<List<Long>> trackIdListResult = userInfoFeignClient.findUserPaidTrackList(trackInfo.getAlbumId());
        Assert.notNull(trackIdListResult, "查询用户付费声音失败");
        List<Long> trackIdList = trackIdListResult.getData();
        //  从当前声音Id开始计算有多少声音是需要付费的集合Id;
        //  select * from track_info where order_num > 8 and album_id = 341;
        //  7--54  trackIdListResult {17,18,19}
        List<TrackInfo> trackInfoList = trackInfoMapper.selectList(new LambdaQueryWrapper<TrackInfo>()
                .eq(TrackInfo::getAlbumId, trackInfo.getAlbumId())
                .gt(TrackInfo::getOrderNum, trackInfo.getOrderNum()));

        //  两个集合取差集,需要付费的声音列表;
        List<TrackInfo> paidTrackIdList = trackInfoList.stream().filter(trackInfoItem -> !trackIdList.contains(trackInfoItem.getId())).collect(Collectors.toList());
        //获取专辑来查询声音的单集价格
        AlbumInfo albumInfo = albumInfoMapper.selectById(trackInfo.getAlbumId());
        //判断
        //本集
        if (paidTrackIdList.size() >= 0) {
            Map<String, Object> map = new HashMap<>();
            map.put("name", "本集");
            map.put("price", albumInfo.getPrice());
            map.put("trackCount", 0);
            // 添加到集合中
            list.add(map);
        }
        //后9集
        if (paidTrackIdList.size() > 0 && paidTrackIdList.size() <= 10) {
            //  显示后size集;
            HashMap<String, Object> map = new HashMap<>();
            map.put("name", "后" + paidTrackIdList.size() + "集");
            //使用字符串来确保精度
            map.put("price", albumInfo.getPrice().multiply(new BigDecimal(String.valueOf(paidTrackIdList.size()))));
            map.put("trackCount", paidTrackIdList.size());
            // 添加到集合中
            list.add(map);
        }
        //后10集
        if (paidTrackIdList.size() > 10) {
            HashMap<String, Object> map = new HashMap<>();
            // 显示后10集;
            map.put("name", "后10集");
            map.put("price", albumInfo.getPrice().multiply(new BigDecimal("10")));
            map.put("trackCount", 10);
            // 添加到集合中
            list.add(map);
        }
        //后集
        if (paidTrackIdList.size() > 10 && paidTrackIdList.size() <= 20) {
            //  显示后size集;
            HashMap<String, Object> map = new HashMap<>();
            map.put("name", "后" + paidTrackIdList.size() + "集");
            //使用字符串来确保精度
            map.put("price", albumInfo.getPrice().multiply(new BigDecimal(String.valueOf(paidTrackIdList.size()))));
            map.put("trackCount", paidTrackIdList.size());
            // 添加到集合中
            list.add(map);
        }
        //后20集
        if (paidTrackIdList.size() > 20) {
            HashMap<String, Object> map = new HashMap<>();
            // 显示后10集;
            map.put("name", "后20集");
            map.put("price", albumInfo.getPrice().multiply(new BigDecimal("20")));
            map.put("trackCount", 20);
            // 添加到集合中
            list.add(map);
        }
        // 返回数据
        return list;
    }

    @Override
    public List<TrackInfo> findPaidTrackInfoList(Long trackId, Integer trackCount, Long userId) {
        //创建集合
        List<TrackInfo> trackInfoList = new ArrayList<>();
        //1. 获取用户购买的声音列表
        //通过声音id获取声音对象里的专辑id
        TrackInfo trackInfo = this.getById(trackId);
        Result<List<Long>> userPaidTrackListResult = userInfoFeignClient.findUserPaidTrackList(trackInfo.getAlbumId());
        Assert.notNull(userPaidTrackListResult, "查询用户付费声音失败");
        //集合可以为空
        List<Long> userPaidTrackIdList = userPaidTrackListResult.getData();

        //判断当前购买集数
        if (trackCount == 0) {
            //购买本集
            trackInfoList.add(trackInfo);
        } else {
            //设置查询条件
            //#主要看刚用户是否购买过声音集合;没有购买;
            //select * from track info where order num >8 and album_id = 341 limit 10;
            //#有购买;
            //select * from track info where order num > 8 and album id = 341 and id not in (18036,18037) limit 10.
            LambdaQueryWrapper<TrackInfo> wrapper = new LambdaQueryWrapper<>();
            wrapper.gt(TrackInfo::getOrderNum, trackInfo.getOrderNum()).eq(TrackInfo::getAlbumId, trackInfo.getAlbumId());
            if (!CollectionUtils.isEmpty(userPaidTrackIdList)) {
                //排除用户已购买
                wrapper.notIn(TrackInfo::getId, userPaidTrackIdList);
            }
            wrapper.last(" limit " + trackCount);
            //查询数据
            trackInfoList = trackInfoMapper.selectList(wrapper);
        }
        return trackInfoList;
    }
}
